"192.168.0.1:sipop" Previous topic Chapter index Next topic

TIPOREQUISICION

 

 

Descriptions

TIPO DE REQUISICION O SOLICITUD DE MATERIALES

 

Fields

PK

FK

Name

Domain

Data type

Not null

Default

Description

 

ID_TIPO_REQUISICION

 

CHAR (3)

 

ID Requisicon

 

 

NOMB_TIPO_REQU

 

CHAR (40)

 

Nombre del tipo de requisición

 

 

DESC_TIPO_REQU

 

CHAR (240)

 

 

Descripcion del tipo de requisición

 

Triggers

There are no triggers for table TIPOREQUISICION

 

Indices

There are no indices for table TIPOREQUISICION

 

References

There are no references for table TIPOREQUISICION

 

Referenced

Table

Foreign Key

Fields

FK Fields

DEL Rule

UPD Rule

REQUISICION

INTEG_289

TIPO_REQUISICION

ID_TIPO_REQUISICION

RESTRICT

RESTRICT

 

Definition


CREATE TABLE TIPOREQUISICION (
    ID_TIPO_REQUISICION CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMB_TIPO_REQU CHAR (40) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DESC_TIPO_REQU CHAR (240) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE TIPOREQUISICION ADD PRIMARY KEY (ID_TIPO_REQUISICION);

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic